Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 14170 |
| Missing cells | 13802 |
| Missing cells (%) | 3.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 23.4 MiB |
| Average record size in memory | 1.7 KiB |
Variable types
| Numeric | 12 |
|---|---|
| DateTime | 4 |
| Categorical | 7 |
| Text | 7 |
| Boolean | 1 |
| Unsupported | 1 |
Check-in has constant value "16:00" | Constant |
Check-out has constant value "11:00" | Constant |
ADR is highly overall correlated with Adultos and 3 other fields | High correlation |
Adelanto ya pagado is highly overall correlated with Numero_Reserva | High correlation |
Adultos is highly overall correlated with ADR and 2 other fields | High correlation |
Apartamento is highly overall correlated with Precio_Medio_Historico | High correlation |
Apartamentos_Ocupados is highly overall correlated with Numero_Reserva and 2 other fields | High correlation |
Comisión incluida is highly overall correlated with ADR and 3 other fields | High correlation |
GENIUS is highly overall correlated with Portal de reserva | High correlation |
Numero_Huespedes is highly overall correlated with ADR and 3 other fields | High correlation |
Numero_Reserva is highly overall correlated with Adelanto ya pagado and 4 other fields | High correlation |
Número de noches is highly overall correlated with Comisión incluida and 1 other fields | High correlation |
Pagado is highly overall correlated with Portal de reserva and 1 other fields | High correlation |
Porcentaje_Ocupacion is highly overall correlated with Apartamentos_Ocupados and 2 other fields | High correlation |
Portal de reserva is highly overall correlated with Adultos and 4 other fields | High correlation |
Posición is highly overall correlated with Apartamentos_Ocupados and 3 other fields | High correlation |
Precio is highly overall correlated with ADR and 2 other fields | High correlation |
Precio_Medio_Historico is highly overall correlated with Apartamento | High correlation |
Adelanto ya pagado is highly imbalanced (99.5%) | Imbalance |
Estado is highly imbalanced (69.8%) | Imbalance |
Notas has 818 (5.8%) missing values | Missing |
Detalles de precios has 1585 (11.2%) missing values | Missing |
Numero_Reserva has 3795 (26.8%) missing values | Missing |
Mensaje_Huesped has 3802 (26.8%) missing values | Missing |
BOOKING_NOTE has 3802 (26.8%) missing values | Missing |
Huésped_Token has unique values | Unique |
Teléfono_Token has unique values | Unique |
Email_Token has unique values | Unique |
Lead_Time is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Adultos has 974 (6.9%) zeros | Zeros |
Niños has 11268 (79.5%) zeros | Zeros |
Comisión incluida has 1597 (11.3%) zeros | Zeros |
Numero_Huespedes has 972 (6.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-08-28 06:52:35.044618 |
|---|---|
| Analysis finished | 2024-08-28 06:55:00.560852 |
| Duration | 2 minutes and 25.52 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
Posición
Real number (ℝ)
HIGH CORRELATION
| Distinct | 14153 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42539455 |
| Minimum | 15390136 |
|---|---|
| Maximum | 69854666 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 15390136 |
|---|---|
| 5-th percentile | 20312293 |
| Q1 | 29896706 |
| median | 42156263 |
| Q3 | 53922308 |
| 95-th percentile | 66426171 |
| Maximum | 69854666 |
| Range | 54464530 |
| Interquartile range (IQR) | 24025602 |
Descriptive statistics
| Standard deviation | 14359047 |
|---|---|
| Coefficient of variation (CV) | 0.33754657 |
| Kurtosis | -1.0508953 |
| Mean | 42539455 |
| Median Absolute Deviation (MAD) | 12034506 |
| Skewness | 0.065784625 |
| Sum | 6.0278408 × 1011 |
| Variance | 2.0618224 × 1014 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 50677661 | 2 | < 0.1% |
| 50757695 | 2 | < 0.1% |
| 50895260 | 2 | < 0.1% |
| 51202076 | 2 | < 0.1% |
| 50702258 | 2 | < 0.1% |
| 49378100 | 2 | < 0.1% |
| 50855651 | 2 | < 0.1% |
| 49003082 | 2 | < 0.1% |
| 50738435 | 2 | < 0.1% |
| 49082867 | 2 | < 0.1% |
| Other values (14143) | 14150 |
| Value | Count | Frequency (%) |
| 15390136 | 1 | |
| 16811706 | 1 | |
| 16912662 | 1 | |
| 16982857 | 1 | |
| 16993282 | 1 | |
| 16993297 | 1 | |
| 17038186 | 1 | |
| 17061199 | 1 | |
| 17061202 | 1 | |
| 17112598 | 1 |
| Value | Count | Frequency (%) |
| 69854666 | 1 | |
| 69849111 | 1 | |
| 69847911 | 1 | |
| 69843366 | 1 | |
| 69840491 | 1 | |
| 69840476 | 1 | |
| 69838566 | 1 | |
| 69834011 | 1 | |
| 69818721 | 1 | |
| 69810141 | 1 |
Llegada
Date
| Distinct | 1015 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 221.4 KiB |
| Minimum | 2022-01-01 00:00:00 |
|---|---|
| Maximum | 2024-12-07 00:00:00 |
Histogram with fixed size bins (bins=50)
Salida
Date
| Distinct | 1019 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 221.4 KiB |
| Minimum | 2022-01-02 00:00:00 |
|---|---|
| Maximum | 2024-12-08 00:00:00 |
Histogram with fixed size bins (bins=50)
Apartamento
Categorical
HIGH CORRELATION
| Distinct | 41 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| HD BRUNO | 691 |
|---|---|
| H BMA PRAGA | 685 |
| H - BUA 3P | 643 |
| H BMA BERLIN | 642 |
| H - BUA 4P | 624 |
| Other values (36) |
Length
| Max length | 21 |
|---|---|
| Median length | 16 |
| Mean length | 10.860409 |
| Min length | 8 |
Characters and Unicode
| Total characters | 153892 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | H BMA MONACO |
|---|---|
| 2nd row | H BMA HELSINKI |
| 3rd row | H BMA DUBLIN |
| 4th row | HD-GARAJE 5 |
| 5th row | HD DARIO |
Common Values
| Value | Count | Frequency (%) |
| HD BRUNO | 691 | 4.9% |
| H BMA PRAGA | 685 | 4.8% |
| H - BUA 3P | 643 | 4.5% |
| H BMA BERLIN | 642 | 4.5% |
| H - BUA 4P | 624 | 4.4% |
| H BMA OSLO | 592 | 4.2% |
| H BMA MONACO | 560 | 4.0% |
| HD ELENA | 560 | 4.0% |
| HD CELESTE | 538 | 3.8% |
| H BMA AMSTERDAM | 531 | 3.7% |
| Other values (31) | 8104 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| h | 6493 | |
| bma | 5150 | 14.1% |
| hd | 4865 | 13.3% |
| 1343 | 3.7% | |
| bua | 1343 | 3.7% |
| hg0 | 1293 | 3.5% |
| hg1 | 907 | 2.5% |
| bruno | 691 | 1.9% |
| praga | 685 | 1.9% |
| 3p | 643 | 1.8% |
| Other values (41) | 13098 |
Most occurring characters
| Value | Count | Frequency (%) |
| 22341 | ||
| A | 20951 | |
| H | 15995 | 10.4% |
| B | 9565 | 6.2% |
| D | 8501 | 5.5% |
| E | 7433 | 4.8% |
| R | 7426 | 4.8% |
| M | 7364 | 4.8% |
| I | 6968 | 4.5% |
| O | 6612 | 4.3% |
| Other values (23) | 40736 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 153892 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 22341 | ||
| A | 20951 | |
| H | 15995 | 10.4% |
| B | 9565 | 6.2% |
| D | 8501 | 5.5% |
| E | 7433 | 4.8% |
| R | 7426 | 4.8% |
| M | 7364 | 4.8% |
| I | 6968 | 4.5% |
| O | 6612 | 4.3% |
| Other values (23) | 40736 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 153892 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 22341 | ||
| A | 20951 | |
| H | 15995 | 10.4% |
| B | 9565 | 6.2% |
| D | 8501 | 5.5% |
| E | 7433 | 4.8% |
| R | 7426 | 4.8% |
| M | 7364 | 4.8% |
| I | 6968 | 4.5% |
| O | 6612 | 4.3% |
| Other values (23) | 40736 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 153892 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 22341 | ||
| A | 20951 | |
| H | 15995 | 10.4% |
| B | 9565 | 6.2% |
| D | 8501 | 5.5% |
| E | 7433 | 4.8% |
| R | 7426 | 4.8% |
| M | 7364 | 4.8% |
| I | 6968 | 4.5% |
| O | 6612 | 4.3% |
| Other values (23) | 40736 |
Portal de reserva
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| Booking.com | |
|---|---|
| Airbnb | |
| Reserva directa | |
| Página web | 305 |
Length
| Max length | 15 |
|---|---|
| Median length | 11 |
| Mean length | 10.555963 |
| Min length | 6 |
Characters and Unicode
| Total characters | 149578 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Booking.com |
|---|---|
| 2nd row | Booking.com |
| 3rd row | Booking.com |
| 4th row | Reserva directa |
| 5th row | Booking.com |
Common Values
| Value | Count | Frequency (%) |
| Booking.com | 10387 | |
| Airbnb | 2211 | 15.6% |
| Reserva directa | 1267 | 8.9% |
| Página web | 305 | 2.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| booking.com | 10387 | |
| airbnb | 2211 | 14.0% |
| reserva | 1267 | 8.0% |
| directa | 1267 | 8.0% |
| página | 305 | 1.9% |
| web | 305 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 31161 | |
| i | 14170 | |
| n | 12903 | |
| c | 11654 | 7.8% |
| g | 10692 | 7.1% |
| B | 10387 | 6.9% |
| k | 10387 | 6.9% |
| . | 10387 | 6.9% |
| m | 10387 | 6.9% |
| r | 4745 | 3.2% |
| Other values (13) | 22705 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 149578 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 31161 | |
| i | 14170 | |
| n | 12903 | |
| c | 11654 | 7.8% |
| g | 10692 | 7.1% |
| B | 10387 | 6.9% |
| k | 10387 | 6.9% |
| . | 10387 | 6.9% |
| m | 10387 | 6.9% |
| r | 4745 | 3.2% |
| Other values (13) | 22705 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 149578 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 31161 | |
| i | 14170 | |
| n | 12903 | |
| c | 11654 | 7.8% |
| g | 10692 | 7.1% |
| B | 10387 | 6.9% |
| k | 10387 | 6.9% |
| . | 10387 | 6.9% |
| m | 10387 | 6.9% |
| r | 4745 | 3.2% |
| Other values (13) | 22705 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 149578 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 31161 | |
| i | 14170 | |
| n | 12903 | |
| c | 11654 | 7.8% |
| g | 10692 | 7.1% |
| B | 10387 | 6.9% |
| k | 10387 | 6.9% |
| . | 10387 | 6.9% |
| m | 10387 | 6.9% |
| r | 4745 | 3.2% |
| Other values (13) | 22705 |
Creado
Date
| Distinct | 13652 |
|---|---|
| Distinct (%) | 96.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 221.4 KiB |
| Minimum | 2021-02-12 11:22:00 |
|---|---|
| Maximum | 2024-12-08 23:16:00 |
Histogram with fixed size bins (bins=50)
Adultos
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4637262 |
| Minimum | 0 |
|---|---|
| Maximum | 8 |
| Zeros | 974 |
| Zeros (%) | 6.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.4825747 |
|---|---|
| Coefficient of variation (CV) | 0.60176115 |
| Kurtosis | 1.3205562 |
| Mean | 2.4637262 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.93997218 |
| Sum | 34911 |
| Variance | 2.1980278 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 2 | 6078 | |
| 3 | 2094 | 14.8% |
| 1 | 1943 | 13.7% |
| 4 | 1893 | 13.4% |
| 0 | 974 | 6.9% |
| 5 | 525 | 3.7% |
| 6 | 387 | 2.7% |
| 7 | 197 | 1.4% |
| 8 | 79 | 0.6% |
| Value | Count | Frequency (%) |
| 0 | 974 | 6.9% |
| 1 | 1943 | 13.7% |
| 2 | 6078 | |
| 3 | 2094 | 14.8% |
| 4 | 1893 | 13.4% |
| 5 | 525 | 3.7% |
| 6 | 387 | 2.7% |
| 7 | 197 | 1.4% |
| 8 | 79 | 0.6% |
| Value | Count | Frequency (%) |
| 8 | 79 | 0.6% |
| 7 | 197 | 1.4% |
| 6 | 387 | 2.7% |
| 5 | 525 | 3.7% |
| 4 | 1893 | 13.4% |
| 3 | 2094 | 14.8% |
| 2 | 6078 | |
| 1 | 1943 | 13.7% |
| 0 | 974 | 6.9% |
Niños
Real number (ℝ)
ZEROS
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.36076217 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 11268 |
| Zeros (%) | 79.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.78204965 |
|---|---|
| Coefficient of variation (CV) | 2.1677706 |
| Kurtosis | 4.6467505 |
| Mean | 0.36076217 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.2074318 |
| Sum | 5112 |
| Variance | 0.61160165 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 0 | 11268 | |
| 2 | 1493 | 10.5% |
| 1 | 1086 | 7.7% |
| 3 | 269 | 1.9% |
| 4 | 43 | 0.3% |
| 5 | 6 | < 0.1% |
| 6 | 4 | < 0.1% |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 11268 | |
| 1 | 1086 | 7.7% |
| 2 | 1493 | 10.5% |
| 3 | 269 | 1.9% |
| 4 | 43 | 0.3% |
| 5 | 6 | < 0.1% |
| 6 | 4 | < 0.1% |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7 | 1 | < 0.1% |
| 6 | 4 | < 0.1% |
| 5 | 6 | < 0.1% |
| 4 | 43 | 0.3% |
| 3 | 269 | 1.9% |
| 2 | 1493 | 10.5% |
| 1 | 1086 | 7.7% |
| 0 | 11268 |
Check-in
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 968.7 KiB |
| 16:00 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 70850 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 16:00 |
|---|---|
| 2nd row | 16:00 |
| 3rd row | 16:00 |
| 4th row | 16:00 |
| 5th row | 16:00 |
Common Values
| Value | Count | Frequency (%) |
| 16:00 | 14170 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 16:00 | 14170 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 28340 | |
| 1 | 14170 | |
| 6 | 14170 | |
| : | 14170 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 70850 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 28340 | |
| 1 | 14170 | |
| 6 | 14170 | |
| : | 14170 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 70850 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 28340 | |
| 1 | 14170 | |
| 6 | 14170 | |
| : | 14170 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 70850 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 28340 | |
| 1 | 14170 | |
| 6 | 14170 | |
| : | 14170 |
Check-out
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 968.7 KiB |
| 11:00 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 70850 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 11:00 |
|---|---|
| 2nd row | 11:00 |
| 3rd row | 11:00 |
| 4th row | 11:00 |
| 5th row | 11:00 |
Common Values
| Value | Count | Frequency (%) |
| 11:00 | 14170 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 11:00 | 14170 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 28340 | |
| 0 | 28340 | |
| : | 14170 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 70850 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 28340 | |
| 0 | 28340 | |
| : | 14170 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 70850 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 28340 | |
| 0 | 28340 | |
| : | 14170 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 70850 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 28340 | |
| 0 | 28340 | |
| : | 14170 |
Notas
Text
MISSING
| Distinct | 12819 |
|---|---|
| Distinct (%) | 96.0% |
| Missing | 818 |
| Missing (%) | 5.8% |
| Memory size | 7.5 MiB |
Length
| Max length | 1115 |
|---|---|
| Median length | 921 |
| Mean length | 246.7649 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3294805 |
|---|---|
| Distinct characters | 271 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 12450 ? |
|---|---|
| Unique (%) | 93.2% |
Sample
| 1st row | Número de reserva: 3509184945 Mensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 2.5839 Más información: booker_is_genius Pago por adelantado: 234.90EUR |
|---|---|
| 2nd row | Número de reserva: 3677697588 Mensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** Approximate time of arrival: between 14:00 and 15:00 BOOKING NOTE : Payment charge is EUR 1.045 Más información: booker_is_genius Pago por adelantado: 95.00EUR |
| 3rd row | Número de reserva: 2331981900 Mensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** Approximate time of arrival: between 17:00 and 18:00 BOOKING NOTE : Payment charge is EUR 2.695 Más información: booker_is_genius Pago por adelantado: 245.00EUR |
| 4th row | Trjeta 28.12 |
| 5th row | Número de reserva: 3390950867 Mensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 2.211 Más información: booker_is_genius Pago por adelantado: 201.00EUR |
| Value | Count | Frequency (%) |
| 33554 | 7.4% | |
| de | 15203 | 3.3% |
| reserva | 14291 | 3.1% |
| del | 14163 | 3.1% |
| número | 12598 | 2.8% |
| huésped | 12570 | 2.8% |
| por | 11071 | 2.4% |
| más | 10601 | 2.3% |
| has | 10594 | 2.3% |
| is | 10568 | 2.3% |
| Other values (26516) | 309583 |
Most occurring characters
| Value | Count | Frequency (%) |
| 394201 | 12.0% | |
| e | 238075 | 7.2% |
| a | 181190 | 5.5% |
| o | 132327 | 4.0% |
| r | 127194 | 3.9% |
| n | 122200 | 3.7% |
| s | 119957 | 3.6% |
| i | 113817 | 3.5% |
| d | 90983 | 2.8% |
| E | 86543 | 2.6% |
| Other values (261) | 1688318 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3294805 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 394201 | 12.0% | |
| e | 238075 | 7.2% |
| a | 181190 | 5.5% |
| o | 132327 | 4.0% |
| r | 127194 | 3.9% |
| n | 122200 | 3.7% |
| s | 119957 | 3.6% |
| i | 113817 | 3.5% |
| d | 90983 | 2.8% |
| E | 86543 | 2.6% |
| Other values (261) | 1688318 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3294805 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 394201 | 12.0% | |
| e | 238075 | 7.2% |
| a | 181190 | 5.5% |
| o | 132327 | 4.0% |
| r | 127194 | 3.9% |
| n | 122200 | 3.7% |
| s | 119957 | 3.6% |
| i | 113817 | 3.5% |
| d | 90983 | 2.8% |
| E | 86543 | 2.6% |
| Other values (261) | 1688318 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3294805 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 394201 | 12.0% | |
| e | 238075 | 7.2% |
| a | 181190 | 5.5% |
| o | 132327 | 4.0% |
| r | 127194 | 3.9% |
| n | 122200 | 3.7% |
| s | 119957 | 3.6% |
| i | 113817 | 3.5% |
| d | 90983 | 2.8% |
| E | 86543 | 2.6% |
| Other values (261) | 1688318 |
Precio
Real number (ℝ)
HIGH CORRELATION
| Distinct | 2510 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 230.07198 |
| Minimum | 1.15 |
|---|---|
| Maximum | 7847.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 1.15 |
|---|---|
| 5-th percentile | 45 |
| Q1 | 82 |
| median | 148 |
| Q3 | 272 |
| 95-th percentile | 673.8875 |
| Maximum | 7847.6 |
| Range | 7846.45 |
| Interquartile range (IQR) | 190 |
Descriptive statistics
| Standard deviation | 291.79639 |
|---|---|
| Coefficient of variation (CV) | 1.268283 |
| Kurtosis | 130.74719 |
| Mean | 230.07198 |
| Median Absolute Deviation (MAD) | 77 |
| Skewness | 7.8019184 |
| Sum | 3260120 |
| Variance | 85145.131 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 65 | 280 | 2.0% |
| 20 | 258 | 1.8% |
| 71 | 219 | 1.5% |
| 77 | 206 | 1.5% |
| 59 | 160 | 1.1% |
| 83 | 155 | 1.1% |
| 60 | 140 | 1.0% |
| 53.1 | 135 | 1.0% |
| 40 | 132 | 0.9% |
| 95 | 127 | 0.9% |
| Other values (2500) | 12358 |
| Value | Count | Frequency (%) |
| 1.15 | 1 | < 0.1% |
| 2.25 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 8.91 | 1 | < 0.1% |
| 10 | 26 | |
| 11 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 13.5 | 1 | < 0.1% |
| 15 | 25 | |
| 17.25 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7847.6 | 2 | |
| 7330 | 1 | |
| 5785 | 1 | |
| 5595.25 | 1 | |
| 4097 | 1 | |
| 3886 | 1 | |
| 3800 | 1 | |
| 3738.2 | 1 | |
| 3630 | 1 | |
| 3600 | 1 |
MISSING
| Distinct | 3718 |
|---|---|
| Distinct (%) | 29.5% |
| Missing | 1585 |
| Missing (%) | 11.2% |
| Memory size | 1.2 MiB |
Length
| Max length | 183 |
|---|---|
| Median length | 123 |
| Mean length | 26.489869 |
| Min length | 11 |
Characters and Unicode
| Total characters | 333375 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2074 ? |
|---|---|
| Unique (%) | 16.5% |
Sample
| 1st row | TVA - EUR 21.35 |
|---|---|
| 2nd row | TVA - EUR 8.64 |
| 3rd row | TVA - EUR 22.27 |
| 4th row | IVA - EUR 18.27 |
| 5th row | TVA - EUR 20.27 |
| Value | Count | Frequency (%) |
| eur | 16381 | |
| 16381 | ||
| iva | 5292 | 7.2% |
| tva | 5082 | 6.9% |
| cancellation | 4424 | 6.0% |
| fee | 2212 | 3.0% |
| host | 2212 | 3.0% |
| payout | 2212 | 3.0% |
| price | 1579 | 2.1% |
| security | 1579 | 2.1% |
| Other values (2951) | 16393 |
Most occurring characters
| Value | Count | Frequency (%) |
| 57366 | 17.2% | |
| - | 16381 | 4.9% |
| E | 16381 | 4.9% |
| U | 16381 | 4.9% |
| R | 16381 | 4.9% |
| . | 13796 | 4.1% |
| e | 12006 | 3.6% |
| a | 11068 | 3.3% |
| 1 | 10716 | 3.2% |
| t | 10435 | 3.1% |
| Other values (30) | 152464 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 333375 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 57366 | 17.2% | |
| - | 16381 | 4.9% |
| E | 16381 | 4.9% |
| U | 16381 | 4.9% |
| R | 16381 | 4.9% |
| . | 13796 | 4.1% |
| e | 12006 | 3.6% |
| a | 11068 | 3.3% |
| 1 | 10716 | 3.2% |
| t | 10435 | 3.1% |
| Other values (30) | 152464 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 333375 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 57366 | 17.2% | |
| - | 16381 | 4.9% |
| E | 16381 | 4.9% |
| U | 16381 | 4.9% |
| R | 16381 | 4.9% |
| . | 13796 | 4.1% |
| e | 12006 | 3.6% |
| a | 11068 | 3.3% |
| 1 | 10716 | 3.2% |
| t | 10435 | 3.1% |
| Other values (30) | 152464 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 333375 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 57366 | 17.2% | |
| - | 16381 | 4.9% |
| E | 16381 | 4.9% |
| U | 16381 | 4.9% |
| R | 16381 | 4.9% |
| . | 13796 | 4.1% |
| e | 12006 | 3.6% |
| a | 11068 | 3.3% |
| 1 | 10716 | 3.2% |
| t | 10435 | 3.1% |
| Other values (30) | 152464 |
Comisión incluida
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 2221 |
|---|---|
| Distinct (%) | 15.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.099969 |
| Minimum | 0 |
|---|---|
| Maximum | 867.75 |
| Zeros | 1597 |
| Zeros (%) | 11.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10.65 |
| median | 20.535 |
| Q3 | 38.34 |
| 95-th percentile | 95.1995 |
| Maximum | 867.75 |
| Range | 867.75 |
| Interquartile range (IQR) | 27.69 |
Descriptive statistics
| Standard deviation | 37.941852 |
|---|---|
| Coefficient of variation (CV) | 1.2199965 |
| Kurtosis | 59.489679 |
| Mean | 31.099969 |
| Median Absolute Deviation (MAD) | 11.355 |
| Skewness | 5.1843902 |
| Sum | 440686.56 |
| Variance | 1439.5841 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1597 | 11.3% |
| 9.75 | 264 | 1.9% |
| 10.65 | 223 | 1.6% |
| 11.55 | 197 | 1.4% |
| 12.45 | 162 | 1.1% |
| 8.85 | 157 | 1.1% |
| 7.96 | 135 | 1.0% |
| 21.3 | 125 | 0.9% |
| 14.25 | 124 | 0.9% |
| 8.78 | 122 | 0.9% |
| Other values (2211) | 11064 |
| Value | Count | Frequency (%) |
| 0 | 1597 | |
| 0.17 | 1 | < 0.1% |
| 0.34 | 1 | < 0.1% |
| 0.45 | 1 | < 0.1% |
| 1.34 | 1 | < 0.1% |
| 1.5 | 1 | < 0.1% |
| 1.65 | 1 | < 0.1% |
| 1.95 | 1 | < 0.1% |
| 2.02 | 1 | < 0.1% |
| 2.25 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 867.75 | 1 | |
| 839.29 | 1 | |
| 614.55 | 1 | |
| 582.9 | 1 | |
| 560.73 | 1 | |
| 502.95 | 1 | |
| 492 | 1 | |
| 457.5 | 2 | |
| 445.45 | 1 | |
| 443.27 | 1 |
Pagado
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| Sí | |
|---|---|
| No |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 28340 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Sí |
|---|---|
| 2nd row | Sí |
| 3rd row | Sí |
| 4th row | No |
| 5th row | Sí |
Common Values
| Value | Count | Frequency (%) |
| Sí | 11449 | |
| No | 2721 | 19.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| sí | 11449 | |
| no | 2721 | 19.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 11449 | |
| í | 11449 | |
| N | 2721 | 9.6% |
| o | 2721 | 9.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 28340 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 11449 | |
| í | 11449 | |
| N | 2721 | 9.6% |
| o | 2721 | 9.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 28340 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 11449 | |
| í | 11449 | |
| N | 2721 | 9.6% |
| o | 2721 | 9.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 28340 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 11449 | |
| í | 11449 | |
| N | 2721 | 9.6% |
| o | 2721 | 9.6% |
Adelanto ya pagado
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 927.3 KiB |
| No | |
|---|---|
| Sí | 5 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 28340 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No |
|---|---|
| 2nd row | No |
| 3rd row | No |
| 4th row | No |
| 5th row | No |
Common Values
| Value | Count | Frequency (%) |
| No | 14165 | |
| Sí | 5 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 14165 | |
| sí | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 14165 | |
| o | 14165 | |
| S | 5 | < 0.1% |
| í | 5 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 28340 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 14165 | |
| o | 14165 | |
| S | 5 | < 0.1% |
| í | 5 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 28340 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 14165 | |
| o | 14165 | |
| S | 5 | < 0.1% |
| í | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 28340 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 14165 | |
| o | 14165 | |
| S | 5 | < 0.1% |
| í | 5 | < 0.1% |
Número de noches
Real number (ℝ)
HIGH CORRELATION
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8161609 |
| Minimum | 1 |
|---|---|
| Maximum | 81 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 81 |
| Range | 80 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.9504429 |
|---|---|
| Coefficient of variation (CV) | 1.0739373 |
| Kurtosis | 382.5878 |
| Mean | 1.8161609 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.20734 |
| Sum | 25735 |
| Variance | 3.8042275 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=29)
| Value | Count | Frequency (%) |
| 1 | 8206 | |
| 2 | 3436 | |
| 3 | 1407 | 9.9% |
| 4 | 609 | 4.3% |
| 5 | 258 | 1.8% |
| 7 | 78 | 0.6% |
| 6 | 69 | 0.5% |
| 8 | 22 | 0.2% |
| 11 | 11 | 0.1% |
| 9 | 10 | 0.1% |
| Other values (19) | 64 | 0.5% |
| Value | Count | Frequency (%) |
| 1 | 8206 | |
| 2 | 3436 | |
| 3 | 1407 | 9.9% |
| 4 | 609 | 4.3% |
| 5 | 258 | 1.8% |
| 6 | 69 | 0.5% |
| 7 | 78 | 0.6% |
| 8 | 22 | 0.2% |
| 9 | 10 | 0.1% |
| 10 | 10 | 0.1% |
| Value | Count | Frequency (%) |
| 81 | 1 | < 0.1% |
| 62 | 2 | < 0.1% |
| 33 | 1 | < 0.1% |
| 31 | 6 | |
| 30 | 5 | |
| 29 | 2 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 4 | |
| 24 | 1 | < 0.1% |
| 21 | 2 | < 0.1% |
Estado
Categorical
IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| Reservado | |
|---|---|
| Cancelado | |
| Overbooking | 15 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 9.0021171 |
| Min length | 9 |
Characters and Unicode
| Total characters | 127560 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Reservado |
|---|---|
| 2nd row | Reservado |
| 3rd row | Reservado |
| 4th row | Reservado |
| 5th row | Reservado |
Common Values
| Value | Count | Frequency (%) |
| Reservado | 12745 | |
| Cancelado | 1410 | 10.0% |
| Overbooking | 15 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| reservado | 12745 | |
| cancelado | 1410 | 10.0% |
| overbooking | 15 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 26915 | |
| a | 15565 | |
| o | 14185 | |
| d | 14155 | |
| r | 12760 | |
| v | 12760 | |
| R | 12745 | |
| s | 12745 | |
| n | 1425 | 1.1% |
| l | 1410 | 1.1% |
| Other values (7) | 2895 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 127560 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 26915 | |
| a | 15565 | |
| o | 14185 | |
| d | 14155 | |
| r | 12760 | |
| v | 12760 | |
| R | 12745 | |
| s | 12745 | |
| n | 1425 | 1.1% |
| l | 1410 | 1.1% |
| Other values (7) | 2895 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 127560 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 26915 | |
| a | 15565 | |
| o | 14185 | |
| d | 14155 | |
| r | 12760 | |
| v | 12760 | |
| R | 12745 | |
| s | 12745 | |
| n | 1425 | 1.1% |
| l | 1410 | 1.1% |
| Other values (7) | 2895 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 127560 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 26915 | |
| a | 15565 | |
| o | 14185 | |
| d | 14155 | |
| r | 12760 | |
| v | 12760 | |
| R | 12745 | |
| s | 12745 | |
| n | 1425 | 1.1% |
| l | 1410 | 1.1% |
| Other values (7) | 2895 | 2.3% |
Huésped_Token
Text
UNIQUE
| Distinct | 14170 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Characters and Unicode
| Total characters | 510120 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 14170 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | be87b7b4-734b-475a-aedc-b80420360db2 |
|---|---|
| 2nd row | 35e44167-2433-4876-b49b-a4545f1f7838 |
| 3rd row | 36ce4d92-6974-4f4d-be07-64ca05a4d878 |
| 4th row | 5ea7bfa0-4a1a-471a-bbfd-c8ab3d45306b |
| 5th row | 9a4df539-fa60-48b4-ba02-c971b89cd539 |
| Value | Count | Frequency (%) |
| be87b7b4-734b-475a-aedc-b80420360db2 | 1 | < 0.1% |
| 76633f0b-aafc-420e-bffe-7454323e896c | 1 | < 0.1% |
| 5aeb6f79-8019-4ea1-ad9b-bf9cf2edff5f | 1 | < 0.1% |
| 72f1fee8-9e5e-46a5-ad11-0e1270205abb | 1 | < 0.1% |
| 36ce4d92-6974-4f4d-be07-64ca05a4d878 | 1 | < 0.1% |
| 5ea7bfa0-4a1a-471a-bbfd-c8ab3d45306b | 1 | < 0.1% |
| 9a4df539-fa60-48b4-ba02-c971b89cd539 | 1 | < 0.1% |
| b4a1bb5d-b1ff-430d-aed2-0d7c14fe9287 | 1 | < 0.1% |
| 24977c99-4a49-49f7-8b79-b242634b67a8 | 1 | < 0.1% |
| 89bbed20-7c13-4d1a-bc20-14040d849e1f | 1 | < 0.1% |
| Other values (14160) | 14160 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 41080 | 8.1% |
| a | 30286 | 5.9% |
| 9 | 30115 | 5.9% |
| b | 30005 | 5.9% |
| 8 | 29911 | 5.9% |
| 2 | 26918 | 5.3% |
| c | 26861 | 5.3% |
| 1 | 26703 | 5.2% |
| f | 26585 | 5.2% |
| Other values (7) | 184976 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 510120 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 41080 | 8.1% |
| a | 30286 | 5.9% |
| 9 | 30115 | 5.9% |
| b | 30005 | 5.9% |
| 8 | 29911 | 5.9% |
| 2 | 26918 | 5.3% |
| c | 26861 | 5.3% |
| 1 | 26703 | 5.2% |
| f | 26585 | 5.2% |
| Other values (7) | 184976 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 510120 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 41080 | 8.1% |
| a | 30286 | 5.9% |
| 9 | 30115 | 5.9% |
| b | 30005 | 5.9% |
| 8 | 29911 | 5.9% |
| 2 | 26918 | 5.3% |
| c | 26861 | 5.3% |
| 1 | 26703 | 5.2% |
| f | 26585 | 5.2% |
| Other values (7) | 184976 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 510120 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 41080 | 8.1% |
| a | 30286 | 5.9% |
| 9 | 30115 | 5.9% |
| b | 30005 | 5.9% |
| 8 | 29911 | 5.9% |
| 2 | 26918 | 5.3% |
| c | 26861 | 5.3% |
| 1 | 26703 | 5.2% |
| f | 26585 | 5.2% |
| Other values (7) | 184976 |
Teléfono_Token
Text
UNIQUE
| Distinct | 14170 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Characters and Unicode
| Total characters | 510120 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 14170 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | e0c4f0b2-b56a-47ba-acb8-f6a35e572a76 |
|---|---|
| 2nd row | 415c6f96-47af-404d-aa92-720fc0218919 |
| 3rd row | 0a952103-56e5-4232-876f-eba3826afb24 |
| 4th row | adcea205-d9d3-45f5-84df-c636276779c2 |
| 5th row | b240d5b6-2622-4361-a2d4-4815bb25f647 |
| Value | Count | Frequency (%) |
| e0c4f0b2-b56a-47ba-acb8-f6a35e572a76 | 1 | < 0.1% |
| 8b7f1d8a-971f-4800-a519-7e31ed715fa3 | 1 | < 0.1% |
| c280c472-780e-4e50-8bab-0c5905d38c01 | 1 | < 0.1% |
| 06006122-94f2-45b8-ab0c-22810624f274 | 1 | < 0.1% |
| 0a952103-56e5-4232-876f-eba3826afb24 | 1 | < 0.1% |
| adcea205-d9d3-45f5-84df-c636276779c2 | 1 | < 0.1% |
| b240d5b6-2622-4361-a2d4-4815bb25f647 | 1 | < 0.1% |
| 2a189e60-4a59-4efe-9ee6-ba392ff23842 | 1 | < 0.1% |
| 74366778-7b2f-40a3-a7c4-b88271cc0424 | 1 | < 0.1% |
| 3b520c09-8acf-4018-aa96-fea5e1b20f77 | 1 | < 0.1% |
| Other values (14160) | 14160 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 40856 | 8.0% |
| a | 30383 | 6.0% |
| b | 30148 | 5.9% |
| 9 | 30131 | 5.9% |
| 8 | 30107 | 5.9% |
| 0 | 26849 | 5.3% |
| 5 | 26728 | 5.2% |
| 6 | 26650 | 5.2% |
| e | 26562 | 5.2% |
| Other values (7) | 185026 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 510120 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 40856 | 8.0% |
| a | 30383 | 6.0% |
| b | 30148 | 5.9% |
| 9 | 30131 | 5.9% |
| 8 | 30107 | 5.9% |
| 0 | 26849 | 5.3% |
| 5 | 26728 | 5.2% |
| 6 | 26650 | 5.2% |
| e | 26562 | 5.2% |
| Other values (7) | 185026 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 510120 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 40856 | 8.0% |
| a | 30383 | 6.0% |
| b | 30148 | 5.9% |
| 9 | 30131 | 5.9% |
| 8 | 30107 | 5.9% |
| 0 | 26849 | 5.3% |
| 5 | 26728 | 5.2% |
| 6 | 26650 | 5.2% |
| e | 26562 | 5.2% |
| Other values (7) | 185026 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 510120 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 40856 | 8.0% |
| a | 30383 | 6.0% |
| b | 30148 | 5.9% |
| 9 | 30131 | 5.9% |
| 8 | 30107 | 5.9% |
| 0 | 26849 | 5.3% |
| 5 | 26728 | 5.2% |
| 6 | 26650 | 5.2% |
| e | 26562 | 5.2% |
| Other values (7) | 185026 |
Email_Token
Text
UNIQUE
| Distinct | 14170 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Characters and Unicode
| Total characters | 510120 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 14170 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 8f5e9611-e2d7-4299-b5cd-8ffa3780cc21 |
|---|---|
| 2nd row | 513be7e2-5acb-40f1-994d-8b5b71755b3d |
| 3rd row | 81c733f5-6f95-42db-a4ff-6d569ff29ee0 |
| 4th row | deb8b9cf-d436-405c-884e-890910c45722 |
| 5th row | 2b196f6c-9987-441b-a20a-0ab7bdbcc1f2 |
| Value | Count | Frequency (%) |
| 8f5e9611-e2d7-4299-b5cd-8ffa3780cc21 | 1 | < 0.1% |
| adce2f02-3c68-44aa-8382-73258afea378 | 1 | < 0.1% |
| 791d9a60-6175-48d0-a960-b9a71329b1d9 | 1 | < 0.1% |
| 1df2f3a1-9055-4620-aef7-8827078fa422 | 1 | < 0.1% |
| 81c733f5-6f95-42db-a4ff-6d569ff29ee0 | 1 | < 0.1% |
| deb8b9cf-d436-405c-884e-890910c45722 | 1 | < 0.1% |
| 2b196f6c-9987-441b-a20a-0ab7bdbcc1f2 | 1 | < 0.1% |
| f10d0bc9-6c2d-4ef8-afc9-ff8a74f2418c | 1 | < 0.1% |
| 2d83ef75-5f19-4afc-b60f-b7e71200b069 | 1 | < 0.1% |
| c8bd578f-c9cd-428a-b1c7-07c1c611b11d | 1 | < 0.1% |
| Other values (14160) | 14160 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 40799 | 8.0% |
| b | 30274 | 5.9% |
| a | 30205 | 5.9% |
| 9 | 30203 | 5.9% |
| 8 | 29963 | 5.9% |
| c | 26969 | 5.3% |
| 2 | 26792 | 5.3% |
| e | 26657 | 5.2% |
| 5 | 26640 | 5.2% |
| Other values (7) | 184938 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 510120 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 40799 | 8.0% |
| b | 30274 | 5.9% |
| a | 30205 | 5.9% |
| 9 | 30203 | 5.9% |
| 8 | 29963 | 5.9% |
| c | 26969 | 5.3% |
| 2 | 26792 | 5.3% |
| e | 26657 | 5.2% |
| 5 | 26640 | 5.2% |
| Other values (7) | 184938 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 510120 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 40799 | 8.0% |
| b | 30274 | 5.9% |
| a | 30205 | 5.9% |
| 9 | 30203 | 5.9% |
| 8 | 29963 | 5.9% |
| c | 26969 | 5.3% |
| 2 | 26792 | 5.3% |
| e | 26657 | 5.2% |
| 5 | 26640 | 5.2% |
| Other values (7) | 184938 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 510120 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 56680 | 11.1% |
| 4 | 40799 | 8.0% |
| b | 30274 | 5.9% |
| a | 30205 | 5.9% |
| 9 | 30203 | 5.9% |
| 8 | 29963 | 5.9% |
| c | 26969 | 5.3% |
| 2 | 26792 | 5.3% |
| e | 26657 | 5.2% |
| 5 | 26640 | 5.2% |
| Other values (7) | 184938 |
Numero_Reserva
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 10000 |
|---|---|
| Distinct (%) | 96.4% |
| Missing | 3795 |
| Missing (%) | 26.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6433743 × 109 |
| Minimum | 1.0059188 × 109 |
|---|---|
| Maximum | 5.0001592 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 1.0059188 × 109 |
|---|---|
| 5-th percentile | 2.2560339 × 109 |
| Q1 | 2.9356457 × 109 |
| median | 3.8166494 × 109 |
| Q3 | 4.2660505 × 109 |
| 95-th percentile | 4.8337858 × 109 |
| Maximum | 5.0001592 × 109 |
| Range | 3.9942404 × 109 |
| Interquartile range (IQR) | 1.3304048 × 109 |
Descriptive statistics
| Standard deviation | 8.2879556 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.22748021 |
| Kurtosis | -0.8676339 |
| Mean | 3.6433743 × 109 |
| Median Absolute Deviation (MAD) | 6.1324383 × 108 |
| Skewness | -0.35952869 |
| Sum | 3.7800008 × 1013 |
| Variance | 6.8690207 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4283082648 | 8 | 0.1% |
| 4208534781 | 6 | < 0.1% |
| 4242031213 | 5 | < 0.1% |
| 4717565131 | 5 | < 0.1% |
| 3234695754 | 5 | < 0.1% |
| 2944693149 | 4 | < 0.1% |
| 3779868996 | 4 | < 0.1% |
| 4501914314 | 4 | < 0.1% |
| 3017001528 | 4 | < 0.1% |
| 4141710613 | 4 | < 0.1% |
| Other values (9990) | 10326 | |
| (Missing) | 3795 | 26.8% |
| Value | Count | Frequency (%) |
| 1005918761 | 1 | |
| 1005940672 | 1 | |
| 1007108187 | 1 | |
| 1015466631 | 1 | |
| 1021315351 | 1 | |
| 1021317261 | 1 | |
| 1021389587 | 1 | |
| 1029968432 | 1 | |
| 1062900362 | 1 | |
| 1062942205 | 1 |
| Value | Count | Frequency (%) |
| 5000159195 | 1 | |
| 4999865749 | 1 | |
| 4999810028 | 1 | |
| 4999203753 | 1 | |
| 4999049478 | 1 | |
| 4999029286 | 1 | |
| 4998728654 | 1 | |
| 4998674805 | 1 | |
| 4998670026 | 1 | |
| 4998637580 | 1 |
Mensaje_Huesped
Text
MISSING
| Distinct | 1181 |
|---|---|
| Distinct (%) | 11.4% |
| Missing | 3802 |
| Missing (%) | 26.8% |
| Memory size | 1.4 MiB |
Length
| Max length | 824 |
|---|---|
| Median length | 0 |
| Mean length | 32.658854 |
| Min length | 0 |
Characters and Unicode
| Total characters | 338607 |
|---|---|
| Distinct characters | 108 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1104 ? |
|---|---|
| Unique (%) | 10.6% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| and | 1214 | 2.9% |
| of | 1212 | 2.9% |
| time | 1189 | 2.9% |
| arrival | 1184 | 2.9% |
| between | 1183 | 2.9% |
| approximate | 1179 | 2.9% |
| en | 897 | 2.2% |
| smart | 856 | 2.1% |
| flex | 856 | 2.1% |
| de | 778 | 1.9% |
| Other values (2784) | 30609 |
Most occurring characters
| Value | Count | Frequency (%) |
| 38323 | 11.3% | |
| e | 27439 | 8.1% |
| a | 25668 | 7.6% |
| t | 19319 | 5.7% |
| i | 19249 | 5.7% |
| n | 18730 | 5.5% |
| o | 17789 | 5.3% |
| r | 14588 | 4.3% |
| s | 13743 | 4.1% |
| l | 11412 | 3.4% |
| Other values (98) | 132347 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 338607 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 38323 | 11.3% | |
| e | 27439 | 8.1% |
| a | 25668 | 7.6% |
| t | 19319 | 5.7% |
| i | 19249 | 5.7% |
| n | 18730 | 5.5% |
| o | 17789 | 5.3% |
| r | 14588 | 4.3% |
| s | 13743 | 4.1% |
| l | 11412 | 3.4% |
| Other values (98) | 132347 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 338607 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 38323 | 11.3% | |
| e | 27439 | 8.1% |
| a | 25668 | 7.6% |
| t | 19319 | 5.7% |
| i | 19249 | 5.7% |
| n | 18730 | 5.5% |
| o | 17789 | 5.3% |
| r | 14588 | 4.3% |
| s | 13743 | 4.1% |
| l | 11412 | 3.4% |
| Other values (98) | 132347 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 338607 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 38323 | 11.3% | |
| e | 27439 | 8.1% |
| a | 25668 | 7.6% |
| t | 19319 | 5.7% |
| i | 19249 | 5.7% |
| n | 18730 | 5.5% |
| o | 17789 | 5.3% |
| r | 14588 | 4.3% |
| s | 13743 | 4.1% |
| l | 11412 | 3.4% |
| Other values (98) | 132347 |
BOOKING_NOTE
Text
MISSING
| Distinct | 2245 |
|---|---|
| Distinct (%) | 21.7% |
| Missing | 3802 |
| Missing (%) | 26.8% |
| Memory size | 1.1 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 27 |
| Mean length | 27.456308 |
| Min length | 25 |
Characters and Unicode
| Total characters | 284667 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1046 ? |
|---|---|
| Unique (%) | 10.1% |
Sample
| 1st row | Payment charge is EUR 2.5839 |
|---|---|
| 2nd row | Payment charge is EUR 1.045 |
| 3rd row | Payment charge is EUR 2.695 |
| 4th row | Payment charge is EUR 2.211 |
| 5th row | Payment charge is EUR 2.453 |
| Value | Count | Frequency (%) |
| payment | 10368 | |
| eur | 10368 | |
| charge | 10368 | |
| is | 10368 | |
| 0.715 | 175 | 0.3% |
| 0.781 | 160 | 0.3% |
| 0.649 | 154 | 0.3% |
| 0.5841 | 136 | 0.3% |
| 0.6435 | 121 | 0.2% |
| 0.847 | 118 | 0.2% |
| Other values (2239) | 9504 |
Most occurring characters
| Value | Count | Frequency (%) |
| 41472 | 14.6% | |
| e | 20736 | 7.3% |
| a | 20736 | 7.3% |
| P | 10368 | 3.6% |
| g | 10368 | 3.6% |
| . | 10368 | 3.6% |
| R | 10368 | 3.6% |
| U | 10368 | 3.6% |
| s | 10368 | 3.6% |
| i | 10368 | 3.6% |
| Other values (18) | 129147 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 284667 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 41472 | 14.6% | |
| e | 20736 | 7.3% |
| a | 20736 | 7.3% |
| P | 10368 | 3.6% |
| g | 10368 | 3.6% |
| . | 10368 | 3.6% |
| R | 10368 | 3.6% |
| U | 10368 | 3.6% |
| s | 10368 | 3.6% |
| i | 10368 | 3.6% |
| Other values (18) | 129147 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 284667 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 41472 | 14.6% | |
| e | 20736 | 7.3% |
| a | 20736 | 7.3% |
| P | 10368 | 3.6% |
| g | 10368 | 3.6% |
| . | 10368 | 3.6% |
| R | 10368 | 3.6% |
| U | 10368 | 3.6% |
| s | 10368 | 3.6% |
| i | 10368 | 3.6% |
| Other values (18) | 129147 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 284667 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 41472 | 14.6% | |
| e | 20736 | 7.3% |
| a | 20736 | 7.3% |
| P | 10368 | 3.6% |
| g | 10368 | 3.6% |
| . | 10368 | 3.6% |
| R | 10368 | 3.6% |
| U | 10368 | 3.6% |
| s | 10368 | 3.6% |
| i | 10368 | 3.6% |
| Other values (18) | 129147 |
GENIUS
Boolean
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 124.5 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 9045 | |
| False | 5125 |
Numero_Huespedes
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.8244884 |
| Minimum | 0 |
|---|---|
| Maximum | 8 |
| Zeros | 972 |
| Zeros (%) | 6.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.6395601 |
|---|---|
| Coefficient of variation (CV) | 0.5804804 |
| Kurtosis | 0.27807467 |
| Mean | 2.8244884 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.52656568 |
| Sum | 40023 |
| Variance | 2.6881574 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 2 | 4108 | |
| 4 | 3226 | |
| 3 | 2413 | |
| 1 | 1763 | |
| 0 | 972 | 6.9% |
| 5 | 776 | 5.5% |
| 6 | 481 | 3.4% |
| 7 | 313 | 2.2% |
| 8 | 118 | 0.8% |
| Value | Count | Frequency (%) |
| 0 | 972 | 6.9% |
| 1 | 1763 | |
| 2 | 4108 | |
| 3 | 2413 | |
| 4 | 3226 | |
| 5 | 776 | 5.5% |
| 6 | 481 | 3.4% |
| 7 | 313 | 2.2% |
| 8 | 118 | 0.8% |
| Value | Count | Frequency (%) |
| 8 | 118 | 0.8% |
| 7 | 313 | 2.2% |
| 6 | 481 | 3.4% |
| 5 | 776 | 5.5% |
| 4 | 3226 | |
| 3 | 2413 | |
| 2 | 4108 | |
| 1 | 1763 | |
| 0 | 972 | 6.9% |
Lead_Time
Unsupported
REJECTED UNSUPPORTED
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 221.4 KiB |
ADR
Real number (ℝ)
HIGH CORRELATION
| Distinct | 2433 |
|---|---|
| Distinct (%) | 17.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 123.8623 |
| Minimum | 1.15 |
|---|---|
| Maximum | 1502.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 1.15 |
|---|---|
| 5-th percentile | 37.8 |
| Q1 | 71 |
| median | 102 |
| Q3 | 158.33333 |
| 95-th percentile | 266.8875 |
| Maximum | 1502.7 |
| Range | 1501.55 |
| Interquartile range (IQR) | 87.333333 |
Descriptive statistics
| Standard deviation | 82.56586 |
|---|---|
| Coefficient of variation (CV) | 0.66659396 |
| Kurtosis | 19.410191 |
| Mean | 123.8623 |
| Median Absolute Deviation (MAD) | 38 |
| Skewness | 2.8264713 |
| Sum | 1755128.8 |
| Variance | 6817.1212 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20 | 425 | 3.0% |
| 65 | 351 | 2.5% |
| 71 | 326 | 2.3% |
| 77 | 257 | 1.8% |
| 83 | 223 | 1.6% |
| 95 | 184 | 1.3% |
| 59 | 178 | 1.3% |
| 58.5 | 166 | 1.2% |
| 53.1 | 160 | 1.1% |
| 89 | 146 | 1.0% |
| Other values (2423) | 11754 |
| Value | Count | Frequency (%) |
| 1.15 | 1 | < 0.1% |
| 2.25 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 3.333333333 | 1 | < 0.1% |
| 6.666666667 | 1 | < 0.1% |
| 7.5 | 1 | < 0.1% |
| 8.91 | 1 | < 0.1% |
| 10 | 74 | |
| 10.34482759 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1502.7 | 1 | |
| 1145.6 | 1 | |
| 1072 | 1 | |
| 1043.825 | 1 | |
| 1013 | 1 | |
| 989.9 | 1 | |
| 974 | 1 | |
| 971.5 | 1 | |
| 964 | 1 | |
| 900 | 1 |
Precio_Medio_Historico
Real number (ℝ)
HIGH CORRELATION
| Distinct | 13190 |
|---|---|
| Distinct (%) | 93.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 114.35999 |
| Minimum | 10 |
|---|---|
| Maximum | 331.66667 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 38.543098 |
| Q1 | 96.5833 |
| median | 110.49509 |
| Q3 | 123.43788 |
| 95-th percentile | 188.73521 |
| Maximum | 331.66667 |
| Range | 321.66667 |
| Interquartile range (IQR) | 26.854577 |
Descriptive statistics
| Standard deviation | 41.017779 |
|---|---|
| Coefficient of variation (CV) | 0.35867245 |
| Kurtosis | 1.5013639 |
| Mean | 114.35999 |
| Median Absolute Deviation (MAD) | 13.546256 |
| Skewness | 0.36875365 |
| Sum | 1620481.1 |
| Variance | 1682.4582 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 15 | 10 | 0.1% |
| 97.40314123 | 4 | < 0.1% |
| 47 | 4 | < 0.1% |
| 20 | 4 | < 0.1% |
| 105.8033889 | 4 | < 0.1% |
| 184.7025629 | 4 | < 0.1% |
| 127.8431764 | 4 | < 0.1% |
| 103.1859795 | 4 | < 0.1% |
| 113.6441737 | 4 | < 0.1% |
| 99.10422892 | 4 | < 0.1% |
| Other values (13180) | 14124 |
| Value | Count | Frequency (%) |
| 10 | 1 | |
| 10.71428571 | 1 | |
| 10.83333333 | 1 | |
| 11 | 1 | |
| 11.25 | 1 | |
| 11.35 | 1 | |
| 11.37755102 | 1 | |
| 11.40625 | 1 | |
| 11.43617021 | 1 | |
| 11.46226415 | 1 |
| Value | Count | Frequency (%) |
| 331.6666667 | 1 | |
| 330 | 2 | |
| 309.5 | 1 | |
| 275.2 | 1 | |
| 256.5 | 1 | |
| 248.7142857 | 1 | |
| 241.218314 | 2 | |
| 241.1588109 | 2 | |
| 241.0827373 | 1 | |
| 240.9525992 | 1 |
Fecha
Date
| Distinct | 1015 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 221.4 KiB |
| Minimum | 2022-01-01 00:00:00 |
|---|---|
| Maximum | 2024-12-07 00:00:00 |
Histogram with fixed size bins (bins=50)
Apartamentos_Ocupados
Real number (ℝ)
HIGH CORRELATION
| Distinct | 33 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.033945 |
| Minimum | 4 |
|---|---|
| Maximum | 41 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 23 |
| median | 31 |
| Q3 | 40 |
| 95-th percentile | 41 |
| Maximum | 41 |
| Range | 37 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 7.0173689 |
|---|---|
| Coefficient of variation (CV) | 0.22611914 |
| Kurtosis | -0.8753354 |
| Mean | 31.033945 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.042402423 |
| Sum | 439751 |
| Variance | 49.243466 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=33)
| Value | Count | Frequency (%) |
| 31 | 3883 | |
| 23 | 3791 | |
| 40 | 2748 | |
| 30 | 1346 | 9.5% |
| 41 | 1062 | 7.5% |
| 39 | 390 | 2.8% |
| 38 | 107 | 0.8% |
| 22 | 86 | 0.6% |
| 26 | 80 | 0.6% |
| 28 | 78 | 0.6% |
| Other values (23) | 599 | 4.2% |
| Value | Count | Frequency (%) |
| 4 | 2 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 6 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 8 | 0.1% |
| 10 | 18 | |
| 11 | 17 | |
| 12 | 33 | |
| 13 | 21 | |
| 14 | 14 |
| Value | Count | Frequency (%) |
| 41 | 1062 | 7.5% |
| 40 | 2748 | |
| 39 | 390 | 2.8% |
| 38 | 107 | 0.8% |
| 36 | 20 | 0.1% |
| 34 | 24 | 0.2% |
| 32 | 17 | 0.1% |
| 31 | 3883 | |
| 30 | 1346 | 9.5% |
| 29 | 42 | 0.3% |
Porcentaje_Ocupacion
Real number (ℝ)
HIGH CORRELATION
| Distinct | 33 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 75.692549 |
| Minimum | 9.7560976 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 221.4 KiB |
Quantile statistics
| Minimum | 9.7560976 |
|---|---|
| 5-th percentile | 56.097561 |
| Q1 | 56.097561 |
| median | 75.609756 |
| Q3 | 97.560976 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 90.243902 |
| Interquartile range (IQR) | 41.463415 |
Descriptive statistics
| Standard deviation | 17.115534 |
|---|---|
| Coefficient of variation (CV) | 0.22611914 |
| Kurtosis | -0.8753354 |
| Mean | 75.692549 |
| Median Absolute Deviation (MAD) | 19.512195 |
| Skewness | -0.042402423 |
| Sum | 1072563.4 |
| Variance | 292.9415 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=33)
| Value | Count | Frequency (%) |
| 75.6097561 | 3883 | |
| 56.09756098 | 3791 | |
| 97.56097561 | 2748 | |
| 73.17073171 | 1346 | 9.5% |
| 100 | 1062 | 7.5% |
| 95.12195122 | 390 | 2.8% |
| 92.68292683 | 107 | 0.8% |
| 53.65853659 | 86 | 0.6% |
| 63.41463415 | 80 | 0.6% |
| 68.29268293 | 78 | 0.6% |
| Other values (23) | 599 | 4.2% |
| Value | Count | Frequency (%) |
| 9.756097561 | 2 | < 0.1% |
| 14.63414634 | 3 | < 0.1% |
| 17.07317073 | 6 | < 0.1% |
| 19.51219512 | 5 | < 0.1% |
| 21.95121951 | 8 | 0.1% |
| 24.3902439 | 18 | |
| 26.82926829 | 17 | |
| 29.26829268 | 33 | |
| 31.70731707 | 21 | |
| 34.14634146 | 14 |
| Value | Count | Frequency (%) |
| 100 | 1062 | 7.5% |
| 97.56097561 | 2748 | |
| 95.12195122 | 390 | 2.8% |
| 92.68292683 | 107 | 0.8% |
| 87.80487805 | 20 | 0.1% |
| 82.92682927 | 24 | 0.2% |
| 78.04878049 | 17 | 0.1% |
| 75.6097561 | 3883 | |
| 73.17073171 | 1346 | 9.5% |
| 70.73170732 | 42 | 0.3% |
| ADR | Adelanto ya pagado | Adultos | Apartamento | Apartamentos_Ocupados | Comisión incluida | Estado | GENIUS | Niños | Numero_Huespedes | Numero_Reserva | Número de noches | Pagado | Porcentaje_Ocupacion | Portal de reserva | Posición | Precio | Precio_Medio_Historico | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ADR | 1.000 | 0.000 | 0.612 | 0.167 | 0.118 | 0.724 | 0.093 | 0.119 | 0.277 | 0.694 | 0.026 | 0.116 | 0.125 | 0.118 | 0.086 | 0.133 | 0.778 | 0.496 |
| Adelanto ya pagado | 0.000 | 1.000 | 0.050 | 0.064 | 0.000 | 0.000 | 0.000 | 0.019 | 0.000 | 0.050 | 1.000 | 0.000 | 0.033 | 0.000 | 0.058 | 0.034 | 0.000 | 0.044 |
| Adultos | 0.612 | 0.050 | 1.000 | 0.402 | 0.047 | 0.446 | 0.057 | 0.365 | -0.023 | 0.853 | -0.020 | -0.052 | 0.383 | 0.047 | 0.505 | 0.043 | 0.415 | 0.434 |
| Apartamento | 0.167 | 0.064 | 0.402 | 1.000 | 0.119 | 0.071 | 0.059 | 0.402 | 0.115 | 0.445 | 0.000 | 0.059 | 0.298 | 0.119 | 0.475 | 0.194 | 0.082 | 0.683 |
| Apartamentos_Ocupados | 0.118 | 0.000 | 0.047 | 0.119 | 1.000 | 0.057 | 0.000 | 0.152 | 0.019 | 0.049 | 0.703 | -0.030 | 0.277 | 1.000 | 0.063 | 0.898 | 0.064 | 0.265 |
| Comisión incluida | 0.724 | 0.000 | 0.446 | 0.071 | 0.057 | 1.000 | 0.062 | 0.071 | 0.224 | 0.507 | -0.009 | 0.543 | 0.077 | 0.057 | 0.051 | 0.061 | 0.871 | 0.318 |
| Estado | 0.093 | 0.000 | 0.057 | 0.059 | 0.000 | 0.062 | 1.000 | 0.046 | 0.000 | 0.055 | 0.120 | 0.025 | 0.081 | 0.000 | 0.087 | 0.027 | 0.062 | 0.040 |
| GENIUS | 0.119 | 0.019 | 0.365 | 0.402 | 0.152 | 0.071 | 0.046 | 1.000 | 0.164 | 0.365 | 0.189 | 0.053 | 0.418 | 0.152 | 0.802 | 0.184 | 0.030 | 0.295 |
| Niños | 0.277 | 0.000 | -0.023 | 0.115 | 0.019 | 0.224 | 0.000 | 0.164 | 1.000 | 0.458 | -0.009 | 0.005 | 0.121 | 0.019 | 0.111 | 0.032 | 0.195 | 0.169 |
| Numero_Huespedes | 0.694 | 0.050 | 0.853 | 0.445 | 0.049 | 0.507 | 0.055 | 0.365 | 0.458 | 1.000 | -0.025 | -0.040 | 0.384 | 0.049 | 0.504 | 0.051 | 0.474 | 0.482 |
| Numero_Reserva | 0.026 | 1.000 | -0.020 | 0.000 | 0.703 | -0.009 | 0.120 | 0.189 | -0.009 | -0.025 | 1.000 | -0.042 | 0.188 | 0.703 | 1.000 | 0.801 | -0.010 | 0.201 |
| Número de noches | 0.116 | 0.000 | -0.052 | 0.059 | -0.030 | 0.543 | 0.025 | 0.053 | 0.005 | -0.040 | -0.042 | 1.000 | 0.070 | -0.030 | 0.077 | -0.040 | 0.676 | -0.017 |
| Pagado | 0.125 | 0.033 | 0.383 | 0.298 | 0.277 | 0.077 | 0.081 | 0.418 | 0.121 | 0.384 | 0.188 | 0.070 | 1.000 | 0.277 | 0.602 | 0.526 | 0.035 | 0.294 |
| Porcentaje_Ocupacion | 0.118 | 0.000 | 0.047 | 0.119 | 1.000 | 0.057 | 0.000 | 0.152 | 0.019 | 0.049 | 0.703 | -0.030 | 0.277 | 1.000 | 0.063 | 0.898 | 0.064 | 0.265 |
| Portal de reserva | 0.086 | 0.058 | 0.505 | 0.475 | 0.063 | 0.051 | 0.087 | 0.802 | 0.111 | 0.504 | 1.000 | 0.077 | 0.602 | 0.063 | 1.000 | 0.098 | 0.038 | 0.408 |
| Posición | 0.133 | 0.034 | 0.043 | 0.194 | 0.898 | 0.061 | 0.027 | 0.184 | 0.032 | 0.051 | 0.801 | -0.040 | 0.526 | 0.898 | 0.098 | 1.000 | 0.067 | 0.295 |
| Precio | 0.778 | 0.000 | 0.415 | 0.082 | 0.064 | 0.871 | 0.062 | 0.030 | 0.195 | 0.474 | -0.010 | 0.676 | 0.035 | 0.064 | 0.038 | 0.067 | 1.000 | 0.364 |
| Precio_Medio_Historico | 0.496 | 0.044 | 0.434 | 0.683 | 0.265 | 0.318 | 0.040 | 0.295 | 0.169 | 0.482 | 0.201 | -0.017 | 0.294 | 0.265 | 0.408 | 0.295 | 0.364 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| Posición | Llegada | Salida | Apartamento | Portal de reserva | Creado | Adultos | Niños | Check-in | Check-out | Notas | Precio | Detalles de precios | Comisión incluida | Pagado | Adelanto ya pagado | Número de noches | Estado | Huésped_Token | Teléfono_Token | Email_Token | Numero_Reserva | Mensaje_Huesped | BOOKING_NOTE | GENIUS | Numero_Huespedes | Lead_Time | ADR | Precio_Medio_Historico | Fecha | Apartamentos_Ocupados | Porcentaje_Ocupacion | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 32474470 | 2022-12-30 | 2023-01-01 | H BMA MONACO | Booking.com | 2022-12-30 15:16:00 | 1.0 | 1.0 | 16:00 | 11:00 | Número de reserva: 3509184945\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID **\n\nBOOKING NOTE : Payment charge is EUR 2.5839\n\nMás información: booker_is_genius\nPago por adelantado: 234.90EUR | 234.9 | TVA - EUR 21.35 | 35.23 | Sí | No | 2 | Reservado | be87b7b4-734b-475a-aedc-b80420360db2 | e0c4f0b2-b56a-47ba-acb8-f6a35e572a76 | 8f5e9611-e2d7-4299-b5cd-8ffa3780cc21 | 3509184945 | Payment charge is EUR 2.5839 | True | 2.0 | 0 days 15:16:00 | 117.45 | 110.427971 | 2022-12-30 | 12.0 | 29.268293 | |
| 1 | 32470780 | 2022-12-30 | 2022-12-31 | H BMA HELSINKI | Booking.com | 2022-12-30 13:38:00 | 2.0 | 0.0 | 16:00 | 11:00 | Número de reserva: 3677697588\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID **\nApproximate time of arrival: between 14:00 and 15:00\nBOOKING NOTE : Payment charge is EUR 1.045\n\nMás información: booker_is_genius\nPago por adelantado: 95.00EUR | 95.0 | TVA - EUR 8.64 | 14.25 | Sí | No | 1 | Reservado | 35e44167-2433-4876-b49b-a4545f1f7838 | 415c6f96-47af-404d-aa92-720fc0218919 | 513be7e2-5acb-40f1-994d-8b5b71755b3d | 3677697588 | Payment charge is EUR 1.045 | True | 2.0 | 0 days 13:38:00 | 95.00 | 111.276875 | 2022-12-30 | 12.0 | 29.268293 | |
| 3 | 32407618 | 2022-12-31 | 2023-01-01 | H BMA DUBLIN | Booking.com | 2022-12-28 20:36:00 | 4.0 | 0.0 | 16:00 | 11:00 | Número de reserva: 2331981900\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID **\nApproximate time of arrival: between 17:00 and 18:00\nBOOKING NOTE : Payment charge is EUR 2.695\n\nMás información: booker_is_genius\nPago por adelantado: 245.00EUR | 245.0 | TVA - EUR 22.27 | 36.75 | Sí | No | 1 | Reservado | 36ce4d92-6974-4f4d-be07-64ca05a4d878 | 0a952103-56e5-4232-876f-eba3826afb24 | 81c733f5-6f95-42db-a4ff-6d569ff29ee0 | 2331981900 | Payment charge is EUR 2.695 | True | 4.0 | -3 days +20:36:00 | 245.00 | 121.511303 | 2022-12-31 | 16.0 | 39.024390 | |
| 4 | 32401555 | 2022-12-28 | 2022-12-30 | HD-GARAJE 5 | Reserva directa | 2022-12-28 18:20:00 | 0.0 | 0.0 | 16:00 | 11:00 | Trjeta 28.12 | 40.0 | NaN | 0.00 | No | No | 2 | Reservado | 5ea7bfa0-4a1a-471a-bbfd-c8ab3d45306b | adcea205-d9d3-45f5-84df-c636276779c2 | deb8b9cf-d436-405c-884e-890910c45722 | NaN | NaN | NaN | False | 0.0 | 0 days 18:20:00 | 20.00 | 14.154531 | 2022-12-28 | 21.0 | 51.219512 |
| 5 | 32400367 | 2022-12-31 | 2023-01-01 | HD DARIO | Booking.com | 2022-12-28 17:53:00 | 2.0 | 0.0 | 16:00 | 11:00 | Número de reserva: 3390950867\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID **\nBOOKING NOTE : Payment charge is EUR 2.211\n\nMás información: booker_is_genius\nPago por adelantado: 201.00EUR | 201.0 | IVA - EUR 18.27 | 30.15 | Sí | No | 1 | Reservado | 9a4df539-fa60-48b4-ba02-c971b89cd539 | b240d5b6-2622-4361-a2d4-4815bb25f647 | 2b196f6c-9987-441b-a20a-0ab7bdbcc1f2 | 3390950867 | Payment charge is EUR 2.211 | True | 2.0 | -3 days +17:53:00 | 201.00 | 108.699008 | 2022-12-31 | 16.0 | 39.024390 | |
| 6 | 32386453 | 2022-12-30 | 2022-12-31 | H BMA GARAJE | Reserva directa | 2022-12-28 12:14:00 | 0.0 | 0.0 | 16:00 | 11:00 | Tarjeta el 28 | 20.0 | NaN | 0.00 | No | No | 1 | Reservado | b4a1bb5d-b1ff-430d-aed2-0d7c14fe9287 | 2a189e60-4a59-4efe-9ee6-ba392ff23842 | f10d0bc9-6c2d-4ef8-afc9-ff8a74f2418c | NaN | NaN | NaN | False | 0.0 | -2 days +12:14:00 | 20.00 | 19.455082 | 2022-12-30 | 12.0 | 29.268293 |
| 7 | 32380606 | 2022-12-28 | 2022-12-29 | H BMA AMSTERDAM | Booking.com | 2022-12-28 09:31:00 | 3.0 | 0.0 | 16:00 | 11:00 | Número de reserva: 3767273557\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID **\nBOOKING NOTE : Payment charge is EUR 2.453\nUse of parking lot is required. Please make a reservation.\n\nMás información: booker_is_genius\nPago por adelantado: 223.00EUR | 223.0 | TVA - EUR 20.27 | 33.45 | Sí | No | 1 | Reservado | 24977c99-4a49-49f7-8b79-b242634b67a8 | 74366778-7b2f-40a3-a7c4-b88271cc0424 | 2d83ef75-5f19-4afc-b60f-b7e71200b069 | 3767273557 | Payment charge is EUR 2.453 | True | 3.0 | 0 days 09:31:00 | 223.00 | 222.863925 | 2022-12-28 | 21.0 | 51.219512 | |
| 8 | 32371789 | 2022-12-29 | 2022-12-30 | H BMA BERLIN | Booking.com | 2022-12-27 22:22:00 | 2.0 | 2.0 | 16:00 | 11:00 | Número de reserva: 3255965673\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID **\nBOOKING NOTE : Payment charge is EUR 2.046\nIl s'agit d'une réservation Smart Flex.\nConditions mises à jour : annulation gratuite jusqu'à 1 jour avant l'arrivée.\nIl s'agit d'une réservation de remplacement. La réservation Smart Flex initiale n° 3478899786 est à présent remplacée dans son intégralité. Si le client paie à l'arrivée, nous vous conseillons de valider la carte de crédit fournie dès que possible.\nSi vous souhaitez en savoir plus, consultez le lien suivant : https://admin.booking.com/hotel/hoteladmin/extranet_ng/manage/booking.html?hotel_id=5420998&res_id=3255965673\n\nPago por adelantado: 186.00EUR | 186.0 | TVA - EUR 16.91 | 27.90 | Sí | No | 1 | Reservado | 89bbed20-7c13-4d1a-bc20-14040d849e1f | 3b520c09-8acf-4018-aa96-fea5e1b20f77 | c8bd578f-c9cd-428a-b1c7-07c1c611b11d | 3255965673 | Payment charge is EUR 2.046 | False | 4.0 | -2 days +22:22:00 | 186.00 | 158.898177 | 2022-12-29 | 21.0 | 51.219512 | |
| 9 | 32369251 | 2022-12-29 | 2022-12-31 | H BMA CHICAGO | Booking.com | 2022-12-27 21:12:00 | 2.0 | 2.0 | 16:00 | 11:00 | Número de reserva: 2802243358\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID **\nBOOKING NOTE : Payment charge is EUR 4.345\nIl s'agit d'une réservation Smart Flex.\nConditions mises à jour : annulation gratuite jusqu'à 1 jour avant l'arrivée.\nSi vous souhaitez en savoir plus, consultez le lien suivant : https://admin.booking.com/hotel/hoteladmin/extranet_ng/manage/booking.html?hotel_id=5420998&res_id=2802243358\nApproximate time of arrival: between 16:00 and 17:00\n\nMás información: booker_is_genius\nPago por adelantado: 395.00EUR | 395.0 | TVA - EUR 35.91 | 59.25 | Sí | No | 2 | Reservado | 129da156-ca0c-43a6-b202-03321f40e6ea | e16f4fb4-c049-4a81-9665-7ea5d9122b5b | 9fda1188-7d57-4040-a992-9603cd98fea9 | 2802243358 | Payment charge is EUR 4.345 | True | 4.0 | -2 days +21:12:00 | 197.50 | 136.810949 | 2022-12-29 | 21.0 | 51.219512 | |
| 10 | 32333332 | 2022-12-29 | 2022-12-30 | H BMA MONACO | Booking.com | 2022-12-26 22:17:00 | 2.0 | 2.0 | 16:00 | 11:00 | Número de reserva: 2634389390\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID **\nIl s'agit d'une réservation Smart Flex.\nConditions mises à jour : annulation gratuite jusqu'à 2 jours avant l'arrivée.\nSi vous souhaitez en savoir plus, consultez le lien suivant : https://admin.booking.com/hotel/hoteladmin/extranet_ng/manage/booking.html?hotel_id=5420998&res_id=2634389390\n\nBOOKING NOTE : Payment charge is EUR 1.287\n\nMás información: booker_is_genius\nPago por adelantado: 117.00EUR | 117.0 | TVA - EUR 10.64 | 17.55 | Sí | No | 1 | Reservado | 7c210ac4-0181-415f-80a9-0d8b22f9a1dd | d66c4f57-98b8-4371-8966-7a47906e8f8f | 1bf43087-449d-4455-b969-f73879373b47 | 2634389390 | Payment charge is EUR 1.287 | True | 4.0 | -3 days +22:17:00 | 117.00 | 110.390200 | 2022-12-29 | 21.0 | 51.219512 |
| Posición | Llegada | Salida | Apartamento | Portal de reserva | Creado | Adultos | Niños | Check-in | Check-out | Notas | Precio | Detalles de precios | Comisión incluida | Pagado | Adelanto ya pagado | Número de noches | Estado | Huésped_Token | Teléfono_Token | Email_Token | Numero_Reserva | Mensaje_Huesped | BOOKING_NOTE | GENIUS | Numero_Huespedes | Lead_Time | ADR | Precio_Medio_Historico | Fecha | Apartamentos_Ocupados | Porcentaje_Ocupacion | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14376 | 49003082 | 2023-12-26 | 2024-05-01 | HD BRUNO | Booking.com | 2023-12-11 23:56:00 | 2.0 | 1.0 | 16:00 | 11:00 | Número de reserva: 4002704862\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 13.98782\n\nDirección: Gh\nES\nMás información: booker_is_genius\nPago por adelantado: 1271.62EUR | 1271.62 | IVA - EUR 115.6 | 190.74 | Sí | No | 10 | Reservado | d672e667-58b6-49d6-834f-9eec2a8e5db5 | 3abf902a-39c8-4498-9537-a5bc4b6544e7 | 66738d3c-6df9-479b-8d0d-859474402db7 | 4002704862 | Payment charge is EUR 13.98782 | True | 3.0 | -15 days +23:56:00 | 127.162 | 102.460535 | 2023-12-26 | 31.0 | 75.609756 | |
| 14377 | 48800213 | 2024-03-02 | 2024-05-02 | H BMA AMSTERDAM | Booking.com | 2023-08-11 16:16:00 | 6.0 | 2.0 | 16:00 | 11:00 | Número de reserva: 4202562635\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 6.0335\n\nMás información: booker_is_genius\nPago por adelantado: 548.50EUR | 548.50 | TVA - EUR 49.86 | 82.28 | Sí | No | 2 | Cancelado | d511d868-97ee-4fcb-81b9-0de9b76eaa2f | 3284ebf3-b0dc-4276-9630-bbb8a1ae40a3 | b9ac2aa8-dfd1-4328-8592-bed846c03710 | 4202562635 | Payment charge is EUR 6.0335 | True | 8.0 | -204 days +16:16:00 | 274.250 | 223.212693 | 2024-03-02 | 40.0 | 97.560976 | |
| 14378 | 48681794 | 2024-01-26 | 2024-01-28 | H BMA BERLIN | Booking.com | 2023-06-11 12:50:00 | 6.0 | 0.0 | 16:00 | 11:00 | Número de reserva: 4128424493\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 5.104\n\nDirección: Arturo Alvarez Buylla n4 6B\nOviedo\nES\nMás información: booker_is_genius\nPago por adelantado: 464.00EUR | 464.00 | TVA - EUR 42.18 | 69.60 | Sí | No | 2 | Reservado | c5ece72d-811b-4416-9020-1bc7189f0468 | 7a8b30f2-e77b-44c0-8d8c-948de75a5ddf | 87a911b1-0324-4a77-9f48-06d1aad30278 | 4128424493 | Payment charge is EUR 5.104 | True | 6.0 | -229 days +12:50:00 | 232.000 | 162.016477 | 2024-01-26 | 40.0 | 97.560976 | |
| 14379 | 48218090 | 2024-02-25 | 2024-02-26 | H BMA MONACO | Booking.com | 2023-10-27 14:42:00 | 2.0 | 2.0 | 16:00 | 11:00 | Número de reserva: 4254973846\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 0.891 Approximate time of arrival: between 11:00 and 12:00\n\nMás información: booker_is_genius\nPago por adelantado: 81.00EUR | 81.00 | TVA - EUR 7.36 | 12.15 | Sí | No | 1 | Reservado | bddb794d-b301-429b-9fe4-0506d161f77d | d6175989-b148-44ab-beb3-94526eff5b94 | aa4e144a-0ccd-48a1-b174-cdbcfbf61d80 | 4254973846 | Approximate time of arrival: between 11:00 and 12:00 | Payment charge is EUR 0.891 | True | 4.0 | -121 days +14:42:00 | 81.000 | 118.916506 | 2024-02-25 | 40.0 | 97.560976 |
| 14380 | 48179030 | 2024-01-22 | 2024-01-24 | HG1 ARTXANDA | Airbnb | 2023-10-26 18:05:00 | 7.0 | 0.0 | 16:00 | 11:00 | Número de reserva: HME2B4WMFN\nIdioma del huésped: es | 327.80 | Cancellation Host Fee - EUR 44.7\nCancellation Payout - EUR 283.1 | 44.70 | No | No | 2 | Cancelado | f865e062-dc87-4fc6-8f71-44891bfb23cf | 1c48cd47-5790-4cfc-a351-428c55590dcc | b9423ed4-d4ac-47da-b723-70a57178a91e | NaN | NaN | NaN | False | 7.0 | -88 days +18:05:00 | 163.900 | 188.358205 | 2024-01-22 | 40.0 | 97.560976 |
| 14381 | 48020365 | 2024-06-17 | 2024-06-21 | H - BUA 3P | Reserva directa | 2023-10-23 12:17:00 | 1.0 | 0.0 | 16:00 | 11:00 | Viene con un grupo del hostel. | 520.00 | NaN | 0.00 | No | No | 4 | Reservado | 3f799401-19e1-42e6-bef4-fb4ea4ea89ea | aa1f4b17-0bc4-4b9b-a997-34607ef59b96 | dc47a9ec-df04-470b-bad7-f77be13f4f44 | NaN | NaN | NaN | False | 1.0 | -238 days +12:17:00 | 130.000 | 84.024558 | 2024-06-17 | 40.0 | 97.560976 |
| 14382 | 46670629 | 2024-11-02 | 2024-12-02 | H BMA AMSTERDAM | Booking.com | 2023-09-26 14:51:00 | 7.0 | 0.0 | 16:00 | 11:00 | Número de reserva: 4232587055\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 1.75175\n\nMás información: booker_is_genius\nPago por adelantado: 159.25EUR | 159.25 | TVA - EUR 14.48 | 23.89 | Sí | No | 1 | Cancelado | 9e67d79d-6df1-4eb0-bb8f-ab6c4d6b8f35 | 8d2598f6-09a7-45b6-b6df-56f31168bd6a | 80331c7b-6d26-4173-83ab-bd0ef9cab8f2 | 4232587055 | Payment charge is EUR 1.75175 | True | 7.0 | -403 days +14:51:00 | 159.250 | 240.824767 | 2024-11-02 | 40.0 | 97.560976 | |
| 14383 | 46642321 | 2024-12-01 | 2024-01-14 | H BMA BERLIN | Booking.com | 2023-09-25 23:26:00 | 6.0 | 0.0 | 16:00 | 11:00 | Número de reserva: 4237415932\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** Approximate time of arrival: between 17:00 and 18:00 BOOKING NOTE : Payment charge is EUR 13.1274\n\nMás información: booker_is_genius\nPago por adelantado: 1193.40EUR | 521.60 | TVA - EUR 47.42 | 78.24 | Sí | No | 2 | Cancelado | eb94c289-3eee-433c-9966-b16fdb114ddd | 707e7188-43ba-4a80-b705-5efc1e895e66 | 0b46585e-a500-4cdc-9f54-e4017a1d8ec5 | 4237415932 | Payment charge is EUR 13.1274 | True | 6.0 | -433 days +23:26:00 | 260.800 | 163.806629 | 2024-12-01 | 38.0 | 92.682927 | |
| 14384 | 46642318 | 2024-12-01 | 2024-01-14 | H BMA AMSTERDAM | Booking.com | 2023-09-25 23:26:00 | 5.0 | 0.0 | 16:00 | 11:00 | Número de reserva: 4237415932\nMensaje del huésped: ** THIS RESERVATION HAS BEEN PRE-PAID ** Approximate time of arrival: between 17:00 and 18:00 BOOKING NOTE : Payment charge is EUR 13.1274\n\nMás información: booker_is_genius\nPago por adelantado: 1193.40EUR | 671.80 | TVA - EUR 61.07 | 100.77 | Sí | No | 2 | Cancelado | 5e5b0b39-996b-4856-b0c6-4ce853e664af | 3c361138-e3ee-408e-bbfc-5e093f84fd9b | 3bfa3195-68fa-4d88-bd73-5c14c41e88ef | 4237415932 | Payment charge is EUR 13.1274 | True | 5.0 | -433 days +23:26:00 | 335.900 | 241.218314 | 2024-12-01 | 38.0 | 92.682927 | |
| 14385 | 45005552 | 2024-08-01 | 2024-10-01 | HG0 MUGARRA | Airbnb | 2023-08-26 11:09:00 | 7.0 | 0.0 | 16:00 | 11:00 | Número de reserva: HM9ENYC99S\nIdioma del huésped: en | 261.80 | Cancellation Host Fee - EUR 35.7\nCancellation Payout - EUR 226.1 | 35.70 | Sí | No | 2 | Reservado | f7796185-6cbb-4635-8ae2-acaf7d8c7ce4 | 8af45e0d-0e83-4ac4-b980-923c5568d423 | bd13918b-0703-474c-bf94-63efc036e530 | NaN | NaN | NaN | False | 7.0 | -341 days +11:09:00 | 130.900 | 182.386070 | 2024-08-01 | 40.0 | 97.560976 |